IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetAllInstitutions]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetAllInstitutions]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/***************************************************************************
* Name:			GetAllInstitutions
* Purpose:		Returns all the distinct institutions. 
*
*
* PARAMETERS
* Name			Description					
* -------------		-----------------------------------------------------------
*
***************************************************************************/

CREATE PROCEDURE dbo.[GetAllInstitutions]
AS
BEGIN
	SET NOCOUNT ON

	select id, [name] from dbo.FwkDomainOrganization
	where fwkdomainorganizationtypeid = 2

	SET NOCOUNT OFF
END

GO
